/*
*
* SalesProductionBeanExample.java
* @author 18304
* @date 2020-11-18 11:07:46
*/
package com.steel.yfmall.cloud.assistant.po.view;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SalesProductionBeanExample {
    /**
     * zg_sales_production
     */
    protected String orderByClause;

    /**
     * zg_sales_production
     */
    protected boolean distinct;

    /**
     * zg_sales_production
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:zg_sales_production
     * @Title: SalesProductionBeanExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public SalesProductionBeanExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:zg_sales_production
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:zg_sales_production
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2020-11-18 11:07:46
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:zg_sales_production
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:zg_sales_production
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2020-11-18 11:07:46
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:zg_sales_production
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2020-11-18 11:07:46
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:zg_sales_production
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:zg_sales_production
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2020-11-18 11:07:46
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:zg_sales_production
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2020-11-18 11:07:46
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:zg_sales_production
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2020-11-18 11:07:46
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:zg_sales_production
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title zg_sales_production表的实体类
     * @description zg_sales_production
     * @version 1.0
     * @author 18304
     * @date 2020-11-18 11:07:46
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andLoadNoIsNull() {
            addCriterion("load_no is null");
            return (Criteria) this;
        }

        public Criteria andLoadNoIsNotNull() {
            addCriterion("load_no is not null");
            return (Criteria) this;
        }

        public Criteria andLoadNoEqualTo(String value) {
            addCriterion("load_no =", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoNotEqualTo(String value) {
            addCriterion("load_no <>", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoGreaterThan(String value) {
            addCriterion("load_no >", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoGreaterThanOrEqualTo(String value) {
            addCriterion("load_no >=", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoLessThan(String value) {
            addCriterion("load_no <", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoLessThanOrEqualTo(String value) {
            addCriterion("load_no <=", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoLike(String value) {
            addCriterion("load_no like", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoNotLike(String value) {
            addCriterion("load_no not like", value, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoIn(List<String> values) {
            addCriterion("load_no in", values, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoNotIn(List<String> values) {
            addCriterion("load_no not in", values, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoBetween(String value1, String value2) {
            addCriterion("load_no between", value1, value2, "loadNo");
            return (Criteria) this;
        }

        public Criteria andLoadNoNotBetween(String value1, String value2) {
            addCriterion("load_no not between", value1, value2, "loadNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoIsNull() {
            addCriterion("disp_list_no is null");
            return (Criteria) this;
        }

        public Criteria andDispListNoIsNotNull() {
            addCriterion("disp_list_no is not null");
            return (Criteria) this;
        }

        public Criteria andDispListNoEqualTo(String value) {
            addCriterion("disp_list_no =", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoNotEqualTo(String value) {
            addCriterion("disp_list_no <>", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoGreaterThan(String value) {
            addCriterion("disp_list_no >", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoGreaterThanOrEqualTo(String value) {
            addCriterion("disp_list_no >=", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoLessThan(String value) {
            addCriterion("disp_list_no <", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoLessThanOrEqualTo(String value) {
            addCriterion("disp_list_no <=", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoLike(String value) {
            addCriterion("disp_list_no like", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoNotLike(String value) {
            addCriterion("disp_list_no not like", value, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoIn(List<String> values) {
            addCriterion("disp_list_no in", values, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoNotIn(List<String> values) {
            addCriterion("disp_list_no not in", values, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoBetween(String value1, String value2) {
            addCriterion("disp_list_no between", value1, value2, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andDispListNoNotBetween(String value1, String value2) {
            addCriterion("disp_list_no not between", value1, value2, "dispListNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderItemIsNull() {
            addCriterion("order_item is null");
            return (Criteria) this;
        }

        public Criteria andOrderItemIsNotNull() {
            addCriterion("order_item is not null");
            return (Criteria) this;
        }

        public Criteria andOrderItemEqualTo(String value) {
            addCriterion("order_item =", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotEqualTo(String value) {
            addCriterion("order_item <>", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemGreaterThan(String value) {
            addCriterion("order_item >", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemGreaterThanOrEqualTo(String value) {
            addCriterion("order_item >=", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemLessThan(String value) {
            addCriterion("order_item <", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemLessThanOrEqualTo(String value) {
            addCriterion("order_item <=", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemLike(String value) {
            addCriterion("order_item like", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotLike(String value) {
            addCriterion("order_item not like", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemIn(List<String> values) {
            addCriterion("order_item in", values, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotIn(List<String> values) {
            addCriterion("order_item not in", values, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemBetween(String value1, String value2) {
            addCriterion("order_item between", value1, value2, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotBetween(String value1, String value2) {
            addCriterion("order_item not between", value1, value2, "orderItem");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNull() {
            addCriterion("cust_no is null");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNotNull() {
            addCriterion("cust_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustNoEqualTo(String value) {
            addCriterion("cust_no =", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotEqualTo(String value) {
            addCriterion("cust_no <>", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThan(String value) {
            addCriterion("cust_no >", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThanOrEqualTo(String value) {
            addCriterion("cust_no >=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThan(String value) {
            addCriterion("cust_no <", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThanOrEqualTo(String value) {
            addCriterion("cust_no <=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLike(String value) {
            addCriterion("cust_no like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotLike(String value) {
            addCriterion("cust_no not like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoIn(List<String> values) {
            addCriterion("cust_no in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotIn(List<String> values) {
            addCriterion("cust_no not in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoBetween(String value1, String value2) {
            addCriterion("cust_no between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotBetween(String value1, String value2) {
            addCriterion("cust_no not between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andProdNameIsNull() {
            addCriterion("prod_name is null");
            return (Criteria) this;
        }

        public Criteria andProdNameIsNotNull() {
            addCriterion("prod_name is not null");
            return (Criteria) this;
        }

        public Criteria andProdNameEqualTo(String value) {
            addCriterion("prod_name =", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotEqualTo(String value) {
            addCriterion("prod_name <>", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameGreaterThan(String value) {
            addCriterion("prod_name >", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameGreaterThanOrEqualTo(String value) {
            addCriterion("prod_name >=", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameLessThan(String value) {
            addCriterion("prod_name <", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameLessThanOrEqualTo(String value) {
            addCriterion("prod_name <=", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameLike(String value) {
            addCriterion("prod_name like", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotLike(String value) {
            addCriterion("prod_name not like", value, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameIn(List<String> values) {
            addCriterion("prod_name in", values, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotIn(List<String> values) {
            addCriterion("prod_name not in", values, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameBetween(String value1, String value2) {
            addCriterion("prod_name between", value1, value2, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdNameNotBetween(String value1, String value2) {
            addCriterion("prod_name not between", value1, value2, "prodName");
            return (Criteria) this;
        }

        public Criteria andProdspecIsNull() {
            addCriterion("prodspec is null");
            return (Criteria) this;
        }

        public Criteria andProdspecIsNotNull() {
            addCriterion("prodspec is not null");
            return (Criteria) this;
        }

        public Criteria andProdspecEqualTo(String value) {
            addCriterion("prodspec =", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecNotEqualTo(String value) {
            addCriterion("prodspec <>", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecGreaterThan(String value) {
            addCriterion("prodspec >", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecGreaterThanOrEqualTo(String value) {
            addCriterion("prodspec >=", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecLessThan(String value) {
            addCriterion("prodspec <", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecLessThanOrEqualTo(String value) {
            addCriterion("prodspec <=", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecLike(String value) {
            addCriterion("prodspec like", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecNotLike(String value) {
            addCriterion("prodspec not like", value, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecIn(List<String> values) {
            addCriterion("prodspec in", values, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecNotIn(List<String> values) {
            addCriterion("prodspec not in", values, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecBetween(String value1, String value2) {
            addCriterion("prodspec between", value1, value2, "prodspec");
            return (Criteria) this;
        }

        public Criteria andProdspecNotBetween(String value1, String value2) {
            addCriterion("prodspec not between", value1, value2, "prodspec");
            return (Criteria) this;
        }

        public Criteria andPlateNoIsNull() {
            addCriterion("plate_no is null");
            return (Criteria) this;
        }

        public Criteria andPlateNoIsNotNull() {
            addCriterion("plate_no is not null");
            return (Criteria) this;
        }

        public Criteria andPlateNoEqualTo(String value) {
            addCriterion("plate_no =", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotEqualTo(String value) {
            addCriterion("plate_no <>", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoGreaterThan(String value) {
            addCriterion("plate_no >", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoGreaterThanOrEqualTo(String value) {
            addCriterion("plate_no >=", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoLessThan(String value) {
            addCriterion("plate_no <", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoLessThanOrEqualTo(String value) {
            addCriterion("plate_no <=", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoLike(String value) {
            addCriterion("plate_no like", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotLike(String value) {
            addCriterion("plate_no not like", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoIn(List<String> values) {
            addCriterion("plate_no in", values, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotIn(List<String> values) {
            addCriterion("plate_no not in", values, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoBetween(String value1, String value2) {
            addCriterion("plate_no between", value1, value2, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotBetween(String value1, String value2) {
            addCriterion("plate_no not between", value1, value2, "plateNo");
            return (Criteria) this;
        }

        public Criteria andDriverTelIsNull() {
            addCriterion("driver_tel is null");
            return (Criteria) this;
        }

        public Criteria andDriverTelIsNotNull() {
            addCriterion("driver_tel is not null");
            return (Criteria) this;
        }

        public Criteria andDriverTelEqualTo(String value) {
            addCriterion("driver_tel =", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelNotEqualTo(String value) {
            addCriterion("driver_tel <>", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelGreaterThan(String value) {
            addCriterion("driver_tel >", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelGreaterThanOrEqualTo(String value) {
            addCriterion("driver_tel >=", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelLessThan(String value) {
            addCriterion("driver_tel <", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelLessThanOrEqualTo(String value) {
            addCriterion("driver_tel <=", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelLike(String value) {
            addCriterion("driver_tel like", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelNotLike(String value) {
            addCriterion("driver_tel not like", value, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelIn(List<String> values) {
            addCriterion("driver_tel in", values, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelNotIn(List<String> values) {
            addCriterion("driver_tel not in", values, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelBetween(String value1, String value2) {
            addCriterion("driver_tel between", value1, value2, "driverTel");
            return (Criteria) this;
        }

        public Criteria andDriverTelNotBetween(String value1, String value2) {
            addCriterion("driver_tel not between", value1, value2, "driverTel");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNull() {
            addCriterion("warehouse_no is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNotNull() {
            addCriterion("warehouse_no is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoEqualTo(String value) {
            addCriterion("warehouse_no =", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotEqualTo(String value) {
            addCriterion("warehouse_no <>", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThan(String value) {
            addCriterion("warehouse_no >", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThanOrEqualTo(String value) {
            addCriterion("warehouse_no >=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThan(String value) {
            addCriterion("warehouse_no <", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThanOrEqualTo(String value) {
            addCriterion("warehouse_no <=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLike(String value) {
            addCriterion("warehouse_no like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotLike(String value) {
            addCriterion("warehouse_no not like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIn(List<String> values) {
            addCriterion("warehouse_no in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotIn(List<String> values) {
            addCriterion("warehouse_no not in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoBetween(String value1, String value2) {
            addCriterion("warehouse_no between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotBetween(String value1, String value2) {
            addCriterion("warehouse_no not between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andAssignQtyIsNull() {
            addCriterion("assign_qty is null");
            return (Criteria) this;
        }

        public Criteria andAssignQtyIsNotNull() {
            addCriterion("assign_qty is not null");
            return (Criteria) this;
        }

        public Criteria andAssignQtyEqualTo(String value) {
            addCriterion("assign_qty =", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyNotEqualTo(String value) {
            addCriterion("assign_qty <>", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyGreaterThan(String value) {
            addCriterion("assign_qty >", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyGreaterThanOrEqualTo(String value) {
            addCriterion("assign_qty >=", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyLessThan(String value) {
            addCriterion("assign_qty <", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyLessThanOrEqualTo(String value) {
            addCriterion("assign_qty <=", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyLike(String value) {
            addCriterion("assign_qty like", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyNotLike(String value) {
            addCriterion("assign_qty not like", value, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyIn(List<String> values) {
            addCriterion("assign_qty in", values, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyNotIn(List<String> values) {
            addCriterion("assign_qty not in", values, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyBetween(String value1, String value2) {
            addCriterion("assign_qty between", value1, value2, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignQtyNotBetween(String value1, String value2) {
            addCriterion("assign_qty not between", value1, value2, "assignQty");
            return (Criteria) this;
        }

        public Criteria andAssignWgtIsNull() {
            addCriterion("assign_wgt is null");
            return (Criteria) this;
        }

        public Criteria andAssignWgtIsNotNull() {
            addCriterion("assign_wgt is not null");
            return (Criteria) this;
        }

        public Criteria andAssignWgtEqualTo(String value) {
            addCriterion("assign_wgt =", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtNotEqualTo(String value) {
            addCriterion("assign_wgt <>", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtGreaterThan(String value) {
            addCriterion("assign_wgt >", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtGreaterThanOrEqualTo(String value) {
            addCriterion("assign_wgt >=", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtLessThan(String value) {
            addCriterion("assign_wgt <", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtLessThanOrEqualTo(String value) {
            addCriterion("assign_wgt <=", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtLike(String value) {
            addCriterion("assign_wgt like", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtNotLike(String value) {
            addCriterion("assign_wgt not like", value, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtIn(List<String> values) {
            addCriterion("assign_wgt in", values, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtNotIn(List<String> values) {
            addCriterion("assign_wgt not in", values, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtBetween(String value1, String value2) {
            addCriterion("assign_wgt between", value1, value2, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignWgtNotBetween(String value1, String value2) {
            addCriterion("assign_wgt not between", value1, value2, "assignWgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtIsNull() {
            addCriterion("assign_TWgt is null");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtIsNotNull() {
            addCriterion("assign_TWgt is not null");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtEqualTo(String value) {
            addCriterion("assign_TWgt =", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtNotEqualTo(String value) {
            addCriterion("assign_TWgt <>", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtGreaterThan(String value) {
            addCriterion("assign_TWgt >", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtGreaterThanOrEqualTo(String value) {
            addCriterion("assign_TWgt >=", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtLessThan(String value) {
            addCriterion("assign_TWgt <", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtLessThanOrEqualTo(String value) {
            addCriterion("assign_TWgt <=", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtLike(String value) {
            addCriterion("assign_TWgt like", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtNotLike(String value) {
            addCriterion("assign_TWgt not like", value, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtIn(List<String> values) {
            addCriterion("assign_TWgt in", values, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtNotIn(List<String> values) {
            addCriterion("assign_TWgt not in", values, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtBetween(String value1, String value2) {
            addCriterion("assign_TWgt between", value1, value2, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andAssignTwgtNotBetween(String value1, String value2) {
            addCriterion("assign_TWgt not between", value1, value2, "assignTwgt");
            return (Criteria) this;
        }

        public Criteria andRealQtyIsNull() {
            addCriterion("real_qty is null");
            return (Criteria) this;
        }

        public Criteria andRealQtyIsNotNull() {
            addCriterion("real_qty is not null");
            return (Criteria) this;
        }

        public Criteria andRealQtyEqualTo(String value) {
            addCriterion("real_qty =", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyNotEqualTo(String value) {
            addCriterion("real_qty <>", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyGreaterThan(String value) {
            addCriterion("real_qty >", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyGreaterThanOrEqualTo(String value) {
            addCriterion("real_qty >=", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyLessThan(String value) {
            addCriterion("real_qty <", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyLessThanOrEqualTo(String value) {
            addCriterion("real_qty <=", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyLike(String value) {
            addCriterion("real_qty like", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyNotLike(String value) {
            addCriterion("real_qty not like", value, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyIn(List<String> values) {
            addCriterion("real_qty in", values, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyNotIn(List<String> values) {
            addCriterion("real_qty not in", values, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyBetween(String value1, String value2) {
            addCriterion("real_qty between", value1, value2, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealQtyNotBetween(String value1, String value2) {
            addCriterion("real_qty not between", value1, value2, "realQty");
            return (Criteria) this;
        }

        public Criteria andRealWgtIsNull() {
            addCriterion("real_wgt is null");
            return (Criteria) this;
        }

        public Criteria andRealWgtIsNotNull() {
            addCriterion("real_wgt is not null");
            return (Criteria) this;
        }

        public Criteria andRealWgtEqualTo(String value) {
            addCriterion("real_wgt =", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtNotEqualTo(String value) {
            addCriterion("real_wgt <>", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtGreaterThan(String value) {
            addCriterion("real_wgt >", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtGreaterThanOrEqualTo(String value) {
            addCriterion("real_wgt >=", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtLessThan(String value) {
            addCriterion("real_wgt <", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtLessThanOrEqualTo(String value) {
            addCriterion("real_wgt <=", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtLike(String value) {
            addCriterion("real_wgt like", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtNotLike(String value) {
            addCriterion("real_wgt not like", value, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtIn(List<String> values) {
            addCriterion("real_wgt in", values, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtNotIn(List<String> values) {
            addCriterion("real_wgt not in", values, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtBetween(String value1, String value2) {
            addCriterion("real_wgt between", value1, value2, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealWgtNotBetween(String value1, String value2) {
            addCriterion("real_wgt not between", value1, value2, "realWgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtIsNull() {
            addCriterion("real_TWgt is null");
            return (Criteria) this;
        }

        public Criteria andRealTwgtIsNotNull() {
            addCriterion("real_TWgt is not null");
            return (Criteria) this;
        }

        public Criteria andRealTwgtEqualTo(String value) {
            addCriterion("real_TWgt =", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtNotEqualTo(String value) {
            addCriterion("real_TWgt <>", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtGreaterThan(String value) {
            addCriterion("real_TWgt >", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtGreaterThanOrEqualTo(String value) {
            addCriterion("real_TWgt >=", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtLessThan(String value) {
            addCriterion("real_TWgt <", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtLessThanOrEqualTo(String value) {
            addCriterion("real_TWgt <=", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtLike(String value) {
            addCriterion("real_TWgt like", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtNotLike(String value) {
            addCriterion("real_TWgt not like", value, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtIn(List<String> values) {
            addCriterion("real_TWgt in", values, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtNotIn(List<String> values) {
            addCriterion("real_TWgt not in", values, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtBetween(String value1, String value2) {
            addCriterion("real_TWgt between", value1, value2, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andRealTwgtNotBetween(String value1, String value2) {
            addCriterion("real_TWgt not between", value1, value2, "realTwgt");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIsNull() {
            addCriterion("order_price is null");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIsNotNull() {
            addCriterion("order_price is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPriceEqualTo(String value) {
            addCriterion("order_price =", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotEqualTo(String value) {
            addCriterion("order_price <>", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceGreaterThan(String value) {
            addCriterion("order_price >", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceGreaterThanOrEqualTo(String value) {
            addCriterion("order_price >=", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceLessThan(String value) {
            addCriterion("order_price <", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceLessThanOrEqualTo(String value) {
            addCriterion("order_price <=", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceLike(String value) {
            addCriterion("order_price like", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotLike(String value) {
            addCriterion("order_price not like", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIn(List<String> values) {
            addCriterion("order_price in", values, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotIn(List<String> values) {
            addCriterion("order_price not in", values, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceBetween(String value1, String value2) {
            addCriterion("order_price between", value1, value2, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotBetween(String value1, String value2) {
            addCriterion("order_price not between", value1, value2, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andRealAmtIsNull() {
            addCriterion("real_amt is null");
            return (Criteria) this;
        }

        public Criteria andRealAmtIsNotNull() {
            addCriterion("real_amt is not null");
            return (Criteria) this;
        }

        public Criteria andRealAmtEqualTo(String value) {
            addCriterion("real_amt =", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtNotEqualTo(String value) {
            addCriterion("real_amt <>", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtGreaterThan(String value) {
            addCriterion("real_amt >", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtGreaterThanOrEqualTo(String value) {
            addCriterion("real_amt >=", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtLessThan(String value) {
            addCriterion("real_amt <", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtLessThanOrEqualTo(String value) {
            addCriterion("real_amt <=", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtLike(String value) {
            addCriterion("real_amt like", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtNotLike(String value) {
            addCriterion("real_amt not like", value, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtIn(List<String> values) {
            addCriterion("real_amt in", values, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtNotIn(List<String> values) {
            addCriterion("real_amt not in", values, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtBetween(String value1, String value2) {
            addCriterion("real_amt between", value1, value2, "realAmt");
            return (Criteria) this;
        }

        public Criteria andRealAmtNotBetween(String value1, String value2) {
            addCriterion("real_amt not between", value1, value2, "realAmt");
            return (Criteria) this;
        }

        public Criteria andAssignDateIsNull() {
            addCriterion("assign_date is null");
            return (Criteria) this;
        }

        public Criteria andAssignDateIsNotNull() {
            addCriterion("assign_date is not null");
            return (Criteria) this;
        }

        public Criteria andAssignDateEqualTo(String value) {
            addCriterion("assign_date =", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateNotEqualTo(String value) {
            addCriterion("assign_date <>", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateGreaterThan(String value) {
            addCriterion("assign_date >", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateGreaterThanOrEqualTo(String value) {
            addCriterion("assign_date >=", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateLessThan(String value) {
            addCriterion("assign_date <", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateLessThanOrEqualTo(String value) {
            addCriterion("assign_date <=", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateLike(String value) {
            addCriterion("assign_date like", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateNotLike(String value) {
            addCriterion("assign_date not like", value, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateIn(List<String> values) {
            addCriterion("assign_date in", values, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateNotIn(List<String> values) {
            addCriterion("assign_date not in", values, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateBetween(String value1, String value2) {
            addCriterion("assign_date between", value1, value2, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignDateNotBetween(String value1, String value2) {
            addCriterion("assign_date not between", value1, value2, "assignDate");
            return (Criteria) this;
        }

        public Criteria andAssignTimeIsNull() {
            addCriterion("assign_time is null");
            return (Criteria) this;
        }

        public Criteria andAssignTimeIsNotNull() {
            addCriterion("assign_time is not null");
            return (Criteria) this;
        }

        public Criteria andAssignTimeEqualTo(String value) {
            addCriterion("assign_time =", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeNotEqualTo(String value) {
            addCriterion("assign_time <>", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeGreaterThan(String value) {
            addCriterion("assign_time >", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeGreaterThanOrEqualTo(String value) {
            addCriterion("assign_time >=", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeLessThan(String value) {
            addCriterion("assign_time <", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeLessThanOrEqualTo(String value) {
            addCriterion("assign_time <=", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeLike(String value) {
            addCriterion("assign_time like", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeNotLike(String value) {
            addCriterion("assign_time not like", value, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeIn(List<String> values) {
            addCriterion("assign_time in", values, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeNotIn(List<String> values) {
            addCriterion("assign_time not in", values, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeBetween(String value1, String value2) {
            addCriterion("assign_time between", value1, value2, "assignTime");
            return (Criteria) this;
        }

        public Criteria andAssignTimeNotBetween(String value1, String value2) {
            addCriterion("assign_time not between", value1, value2, "assignTime");
            return (Criteria) this;
        }

        public Criteria andLoadDateIsNull() {
            addCriterion("load_date is null");
            return (Criteria) this;
        }

        public Criteria andLoadDateIsNotNull() {
            addCriterion("load_date is not null");
            return (Criteria) this;
        }

        public Criteria andLoadDateEqualTo(String value) {
            addCriterion("load_date =", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateNotEqualTo(String value) {
            addCriterion("load_date <>", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateGreaterThan(String value) {
            addCriterion("load_date >", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateGreaterThanOrEqualTo(String value) {
            addCriterion("load_date >=", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateLessThan(String value) {
            addCriterion("load_date <", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateLessThanOrEqualTo(String value) {
            addCriterion("load_date <=", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateLike(String value) {
            addCriterion("load_date like", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateNotLike(String value) {
            addCriterion("load_date not like", value, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateIn(List<String> values) {
            addCriterion("load_date in", values, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateNotIn(List<String> values) {
            addCriterion("load_date not in", values, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateBetween(String value1, String value2) {
            addCriterion("load_date between", value1, value2, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadDateNotBetween(String value1, String value2) {
            addCriterion("load_date not between", value1, value2, "loadDate");
            return (Criteria) this;
        }

        public Criteria andLoadTimeIsNull() {
            addCriterion("load_time is null");
            return (Criteria) this;
        }

        public Criteria andLoadTimeIsNotNull() {
            addCriterion("load_time is not null");
            return (Criteria) this;
        }

        public Criteria andLoadTimeEqualTo(String value) {
            addCriterion("load_time =", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeNotEqualTo(String value) {
            addCriterion("load_time <>", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeGreaterThan(String value) {
            addCriterion("load_time >", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeGreaterThanOrEqualTo(String value) {
            addCriterion("load_time >=", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeLessThan(String value) {
            addCriterion("load_time <", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeLessThanOrEqualTo(String value) {
            addCriterion("load_time <=", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeLike(String value) {
            addCriterion("load_time like", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeNotLike(String value) {
            addCriterion("load_time not like", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeIn(List<String> values) {
            addCriterion("load_time in", values, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeNotIn(List<String> values) {
            addCriterion("load_time not in", values, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeBetween(String value1, String value2) {
            addCriterion("load_time between", value1, value2, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeNotBetween(String value1, String value2) {
            addCriterion("load_time not between", value1, value2, "loadTime");
            return (Criteria) this;
        }

        public Criteria andCloseDateIsNull() {
            addCriterion("close_date is null");
            return (Criteria) this;
        }

        public Criteria andCloseDateIsNotNull() {
            addCriterion("close_date is not null");
            return (Criteria) this;
        }

        public Criteria andCloseDateEqualTo(String value) {
            addCriterion("close_date =", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateNotEqualTo(String value) {
            addCriterion("close_date <>", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateGreaterThan(String value) {
            addCriterion("close_date >", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateGreaterThanOrEqualTo(String value) {
            addCriterion("close_date >=", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateLessThan(String value) {
            addCriterion("close_date <", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateLessThanOrEqualTo(String value) {
            addCriterion("close_date <=", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateLike(String value) {
            addCriterion("close_date like", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateNotLike(String value) {
            addCriterion("close_date not like", value, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateIn(List<String> values) {
            addCriterion("close_date in", values, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateNotIn(List<String> values) {
            addCriterion("close_date not in", values, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateBetween(String value1, String value2) {
            addCriterion("close_date between", value1, value2, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseDateNotBetween(String value1, String value2) {
            addCriterion("close_date not between", value1, value2, "closeDate");
            return (Criteria) this;
        }

        public Criteria andCloseTimeIsNull() {
            addCriterion("close_time is null");
            return (Criteria) this;
        }

        public Criteria andCloseTimeIsNotNull() {
            addCriterion("close_time is not null");
            return (Criteria) this;
        }

        public Criteria andCloseTimeEqualTo(String value) {
            addCriterion("close_time =", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeNotEqualTo(String value) {
            addCriterion("close_time <>", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeGreaterThan(String value) {
            addCriterion("close_time >", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeGreaterThanOrEqualTo(String value) {
            addCriterion("close_time >=", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeLessThan(String value) {
            addCriterion("close_time <", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeLessThanOrEqualTo(String value) {
            addCriterion("close_time <=", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeLike(String value) {
            addCriterion("close_time like", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeNotLike(String value) {
            addCriterion("close_time not like", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeIn(List<String> values) {
            addCriterion("close_time in", values, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeNotIn(List<String> values) {
            addCriterion("close_time not in", values, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeBetween(String value1, String value2) {
            addCriterion("close_time between", value1, value2, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeNotBetween(String value1, String value2) {
            addCriterion("close_time not between", value1, value2, "closeTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusIsNull() {
            addCriterion("delivery_status is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusIsNotNull() {
            addCriterion("delivery_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusEqualTo(String value) {
            addCriterion("delivery_status =", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusNotEqualTo(String value) {
            addCriterion("delivery_status <>", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusGreaterThan(String value) {
            addCriterion("delivery_status >", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_status >=", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusLessThan(String value) {
            addCriterion("delivery_status <", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusLessThanOrEqualTo(String value) {
            addCriterion("delivery_status <=", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusLike(String value) {
            addCriterion("delivery_status like", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusNotLike(String value) {
            addCriterion("delivery_status not like", value, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusIn(List<String> values) {
            addCriterion("delivery_status in", values, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusNotIn(List<String> values) {
            addCriterion("delivery_status not in", values, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusBetween(String value1, String value2) {
            addCriterion("delivery_status between", value1, value2, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andDeliveryStatusNotBetween(String value1, String value2) {
            addCriterion("delivery_status not between", value1, value2, "deliveryStatus");
            return (Criteria) this;
        }

        public Criteria andAssignStautsIsNull() {
            addCriterion("assign_stauts is null");
            return (Criteria) this;
        }

        public Criteria andAssignStautsIsNotNull() {
            addCriterion("assign_stauts is not null");
            return (Criteria) this;
        }

        public Criteria andAssignStautsEqualTo(String value) {
            addCriterion("assign_stauts =", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsNotEqualTo(String value) {
            addCriterion("assign_stauts <>", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsGreaterThan(String value) {
            addCriterion("assign_stauts >", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsGreaterThanOrEqualTo(String value) {
            addCriterion("assign_stauts >=", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsLessThan(String value) {
            addCriterion("assign_stauts <", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsLessThanOrEqualTo(String value) {
            addCriterion("assign_stauts <=", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsLike(String value) {
            addCriterion("assign_stauts like", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsNotLike(String value) {
            addCriterion("assign_stauts not like", value, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsIn(List<String> values) {
            addCriterion("assign_stauts in", values, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsNotIn(List<String> values) {
            addCriterion("assign_stauts not in", values, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsBetween(String value1, String value2) {
            addCriterion("assign_stauts between", value1, value2, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andAssignStautsNotBetween(String value1, String value2) {
            addCriterion("assign_stauts not between", value1, value2, "assignStauts");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andVersionIntIsNull() {
            addCriterion("version_int is null");
            return (Criteria) this;
        }

        public Criteria andVersionIntIsNotNull() {
            addCriterion("version_int is not null");
            return (Criteria) this;
        }

        public Criteria andVersionIntEqualTo(Integer value) {
            addCriterion("version_int =", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotEqualTo(Integer value) {
            addCriterion("version_int <>", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntGreaterThan(Integer value) {
            addCriterion("version_int >", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntGreaterThanOrEqualTo(Integer value) {
            addCriterion("version_int >=", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntLessThan(Integer value) {
            addCriterion("version_int <", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntLessThanOrEqualTo(Integer value) {
            addCriterion("version_int <=", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntIn(List<Integer> values) {
            addCriterion("version_int in", values, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotIn(List<Integer> values) {
            addCriterion("version_int not in", values, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntBetween(Integer value1, Integer value2) {
            addCriterion("version_int between", value1, value2, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotBetween(Integer value1, Integer value2) {
            addCriterion("version_int not between", value1, value2, "versionInt");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    /**
     * zg_sales_production
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title zg_sales_production表的实体类
     * @description zg_sales_production
     * @version 1.0
     * @author 18304
     * @date 2020-11-18 11:07:46
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
